package org.example.serviceoffice.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.example.model.manage.bean.po.Office;
import org.example.model.manage.bean.po.Major;
import org.example.model.manage.bean.po.Student;
import org.example.model.manage.bean.po.Counselor;
import org.example.model.manage.bean.vo.FacultyCount;
import org.example.model.manage.bean.vo.SchoolCount;
import org.example.model.manage.bean.vo.MajorCount;
import org.example.serviceoffice.vo.StudentListVO;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface OfficeMapper extends BaseMapper<Office> {
    List<FacultyCount> selectAllFacultyCounts();
    SchoolCount selectSchoolCount();
    List<MajorCount> selectMajorCountsByFacultyId(@Param("facultyId") Integer facultyId);
    List<Student> selectStudentsPaged(@Param("offset") int offset, @Param("limit") int limit);
    List<StudentListVO> selectStudentsWithMajorNamePaged(@Param("offset") int offset, @Param("limit") int limit);
    long countStudents();
    List<Counselor> selectCounselorsPaged(@Param("offset") int offset, @Param("limit") int limit);
    long countCounselors();
}